Install the required client

Install one of the supported clients, as described below.

Qlik Replicate for Windows

For all versions of the source database, install Microsoft ODBC Driver 17.6 for SQL Server or later on the Qlik Replicate Server machine.

Qlik Replicate for Linux

1. Install Microsoft ODBC Driver 13 (13.01.0009) for SQL Server or later on the Replicate machine.

2. Change the working directory to <product_dir>/bin.

3. Stop the Replicate service:

   ./areplicate stop

4. Optionally, confirm that the service has stopped:

   ./areplicate status

5. Copy the driver location to the site_arep_login.sh file as follows:

   echo "export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/microsoft/msodbcsql<version>/lib64/" >> site_arep_login.sh

   Example:

   echo "export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/microsoft/msodbcsql17/lib64/" >> site_arep_login.sh

   This will add the driver to "LD_LIBRARY_PATH" and update the driver location in the site_arep_login.sh file.

6. Optionally, confirm that the driver location was copied:

   cat site_arep_login.sh

7. Start the Replicate service:

   ./areplicate start

8. Optionally confirm that the service has started:

   ./areplicate status